<html>
<!-- Use ROW_CLASS alias in SQL to define row style
 for example we highlight all customers from FL
 Also you can use cell values right in CSS, so tr[city="Bogota"] will highlight all rows with City=Bogota.
 Contact field is calculated via expression.
-->
<style>
 {{{defaultstyle}}}
 body {margin: 20px 20px}
 table {box-shadow: 5 5 10 #777;}
 td, th {border: solid #eee 1px; font-size: 12px; padding: 2 2; }
 th {background: #888; color: white; padding: 5px 5px; resize: horizontal; draggable: true; }
 .table-group-box {background: #888; border: solid #555 1px; padding: 3 3; margin: 5 0; color: white }
 .group {background: #8a8; font-weight: bold; font-size: 16px; color: white}


 .FL {background: #ffffaa }
 tr[city="Bogota"] {background: lime}
</style>

<h2>Customer list</h2>
<div class="table-group-box">Drag a column header here to group by that column</div>
<DATAPACKET>
 <METADATA autosort="true">
  <FIELDS>
   <FIELD name="CUSTNO" caption="No"/>
   <FIELD name="COMPANY" caption="Company"/>
   <FIELD name="STATE" caption="State"/>
   <FIELD name="CITY" caption="City" />
   <FIELD name="ADDR1" caption="Street" />
   <FIELD name="PHONE" caption="Phone" />
   <FIELD name="CONTACT" caption="Contact" value="copy(Contact, 1, pos(' ', Contact))"/>
  </FIELDS>
  <SQL>
   select c.*, c.STATE as ROW_CLASS from customer c
  </SQL>
 </METADATA>
</DATAPACKET>

</html>
